1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class UrlWebMod
15 {
16 protected int IdUrl {get; set;}
17 protected string UrlPath {get; set;}
18 protected string Domain {get; set;}
19 protected string TrangThai {get; set;}
20 protected DateTime NgayTao { get; set; }
21 protected int LoadLan { get; set; }
22
23 public UrlWebMod(int _IdUrl)
24 {
25 IdUrl = _IdUrl;
26 }
27
28 public UrlWebMod(string _Domain)
29 {
30 Domain = _Domain;
31 }
32
33 public UrlWebMod(string _UrlPath, int _LoadLan)
34 {
35 UrlPath = _UrlPath;
36 LoadLan = _LoadLan;
37 }
38
39 public UrlWebMod()
40 { }
41
42 public UrlWebMod(int _IdUrl, string _UrlPath, string _Domain, string _TrangThai)
43 {
44 IdUrl = _IdUrl;
45 UrlPath =_UrlPath;
46 Domain = _Domain;
47 TrangThai = _TrangThai;
48
49 }
50
51 public UrlWebMod(int _IdUrl, string _UrlPath, string _Domain, string _TrangThai, DateTime _NgayTao, int _LoadLan)
52 {
53 IdUrl = _IdUrl;
54 UrlPath = _UrlPath;
55 Domain = _Domain;
56 TrangThai = _TrangThai;
57 NgayTao = _NgayTao;
58 LoadLan = _LoadLan;
59 }
60
61 public int InsertUrlWeb()
62 {
63 int i = 0;
64 string[] paras = new string[4] { "@IdUrl", "@UrlPath", "@Domain", "@TrangThai" };
65 object[] values = new object[4] { IdUrl, UrlPath, Domain, TrangThai };
66 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_UrlWeb_Insert", CommandType.StoredProcedure, paras, values));
67 return i;
68 }
69
70 public int Insert2_UrlWeb()
71 {
72 int i = 0;
73 string[] paras = new string[6] { "@IdUrl", "@UrlPath", "@Domain", "@TrangThai" ,"@NgayTao","@LoadLan"};
74 object[] values = new object[6] { IdUrl, UrlPath, Domain, TrangThai, NgayTao, LoadLan };
75 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_UrlWeb_Insert2", CommandType.StoredProcedure, paras, values));
76 return i;
77 }
78
79 public int Update2_UrlWeb()
80 {
81 int i = 0;
82 string[] paras = new string[2] { "@UrlPath", "@LoadLan" };
83 object[] values = new object[2] { UrlPath, LoadLan };
84 i = Models.connection.Excute_Sql("tbl_UrlWeb_Update2", CommandType.StoredProcedure, paras, values);
85 return i;
86 }
87 //hien thi danh sach url
88 public DataSet FillAllDsUrl()
89 {
90 DataSet ds = new DataSet();
91 string[] paras = new string[1] { "@Domain" };
92 object[] values = new object[1] { Domain };
93 ds = Models.connection.FillDataSet("tbl_UrlWeb_GetAllByDomain", CommandType.StoredProcedure, paras, values);
94 return ds;
95 }
96
97 public DataSet FillAllDsUrl_getTenGiaMaSp()
98 {
99 DataSet ds = new DataSet();
100 string[] paras = new string[1] { "@Domain" };
101 object[] values = new object[1] { Domain };
102 ds = Models.connection.FillDataSet("tbl_UrlWeb_Get_Ten_MaSp_Dvt_GiaSp_ByUrl", CommandType.StoredProcedure, paras, values);
103 return ds;
104 }
105
106
107 //lay url load = 0
108 public DataSet FillAllUrl_LoadLan0()
109 {
110 DataSet ds = new DataSet();
111 string[] paras = new string[1] { "@Domain" };
112 object[] values = new object[1] { Domain };
113 ds = Models.connection.FillDataSet("tbl_UrlWeb_GetUrl_LoadLan_0", CommandType.StoredProcedure, paras, values);
114 return ds;
115 }
116 }
117 }